[dbo].[BAEEventSetupCheckMemberType]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupCheckMemberType

Properties
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

create procedure [dbo].[BAEEventSetupCheckMemberType] as
SELECT MEMBER_TYPE, DESCRIPTION
FROM Member_Types
WHERE MEMBER_TYPE NOT IN (SELECT mrc.REGISTRANT_CLASS FROM Meet_Reg_Class mrc);

GO

Uses

[dbo].[Meet_Reg_Class]
[dbo].[Member_Types]
dbo